CREATE VIEW [dbo].[vSoaItemClass]
AS

SELECT 'CERTIFY' AS ItemClassId, 'Certification' AS Name, 'Certification' AS Subscription
UNION
SELECT 'CHAPT' AS ItemClassId, 'Chapter' AS Name, 'Chapter' AS Subscription
UNION
SELECT 'DUES' AS ItemClassId, 'Dues' AS Name, 'Dues' AS Description
UNION
SELECT 'EVENT' AS ItemClassId, 'Event' AS Name, 'Event' AS Description
UNION
SELECT 'GIFT' AS ItemClassId, 'Gift' AS Name, 'Gift' AS Description
UNION
SELECT 'MISC' AS ItemClassId, 'Miscellaneous' AS Name, 'Miscellaneous' AS Description
UNION
SELECT 'SALES' AS ItemClassId, 'Sales' AS Name, 'Sales' AS Description
UNION
SELECT 'SEC' AS ItemClassId, 'Section' AS Name, 'Section' AS Description
UNION
SELECT 'SUB' AS ItemClassId, 'Subscription' AS Name, 'Subscription' AS Description
UNION
SELECT 'VOL' AS ItemClassId, 'Voluntary' AS Name, 'Voluntary' AS Description
UNION
SELECT 'MEETING' AS ItemClassId, 'Event Function' AS Name, 'Event Function' AS Description

GO